<?php 
    $dolar = '$';
    $tablespaces = "SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_DATA_FILES ORDER BY TABLESPACE_NAME;"; 
    $controlfiles = "SELECT NAME FROM V".$dolar."CONTROLFILE;";  
    $archives = "select name from v".$dolar."archived_log;";
    $logfiles = "select member from v".$dolar."logfile;";  
    $spfile = "SELECT VALUE FROM V".$dolar."PARAMETER WHERE NAME = 'spfile';";
    

    